package org.goyo.main.domain.excelBean;

import org.goyo.common.excel.Authentication;
import org.goyo.common.excel.ExcelImportAnnotation;
import org.goyo.common.excel.ExcelImportClassAnnotation;
import org.goyo.main.domain.entity.base.BaseUnitMeasure;
import org.goyo.main.domain.entity.base.Categories;
import org.hibernate.annotations.Type;

import javax.persistence.Column;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;

@ExcelImportClassAnnotation(row="1", sheetNum = { "0" }, sheetAbleNull = { false })
public class MaterialExcel {
  
  /**
   *  商品编码    商品条码    商品分类    商品名称    商品规格    基本计量单位  计量单位    系数  安全库存    最小采购量   条码管理    批次管理    保质期管理   保质期 保质期单位   商品图片    创建人 创建时间    最后修改人   最后修改时间

   */
  
  public MaterialExcel(String number, String barCode, String matCategoryCode, String name,
      String standard, String baseUnit,/*String unit, String coefficient,*/ String safeStock,
      String minPurchaseAmount, Boolean barCodeManage, Boolean lotManage, Boolean expiraDateManage,
      String expiraData, String expiraDataUtil,String picture,String createUserName,String createTime,String updateUserName,String updateTime) {
    super();
    this.number = number;
    this.barCode = barCode;
    this.matCategoryCode = matCategoryCode;
    this.name = name;
    this.standard = standard;
    this.baseUnit = baseUnit;
    /*this.unit = unit;
    this.coefficient = coefficient;*/
    this.safeStock = safeStock;
    this.minPurchaseAmount = minPurchaseAmount;
    if(barCodeManage){
      this.barCodeManage ="是";
    }else{
      this.barCodeManage ="否";
    }
    if(lotManage){
      this.lotManage ="是";
    }else{
      this.lotManage ="否";
    }
    if(expiraDateManage){
      this.expiraDateManage ="是";
    }else{
      this.expiraDateManage ="否";
    }
    this.expiraData = expiraData;
    this.expiraDataUtil = expiraDataUtil;
    this.picture = picture;
    this.createUserName = createUserName;
    this.createTime = createTime;
    this.updateUserName = updateUserName;
    this.updateTime = updateTime;
  }
  public MaterialExcel() {
    super();
  }
  /**
   * 编号
   */
  @ExcelImportAnnotation(column = "0", isDate = false,nullAble= false, columnName = "商品编码")
  private String number;
  
  /**
   * 商品条码
   */
  @ExcelImportAnnotation(column = "1", isDate = false,nullAble=true, columnName = "商品条码")
  private String barCode;
  
  /**
   * 商品分类 
   */
  @ExcelImportAnnotation(column = "2", isDate = false,nullAble=false, columnName = "商品分类")
  private String matCategoryCode;
  /**
   * 名称
   */
  @ExcelImportAnnotation(column = "3", isDate = false,nullAble=false, columnName = "商品名称")
  private String name;
  
  /**
   * 规格型号 
   */
  @ExcelImportAnnotation(column = "4", isDate = false, columnName = "商品规格")
  private String standard;
  

  /**
   * 基本计量单位   
   */
  @ExcelImportAnnotation(column = "5", isDate = false, columnName = "计量单位")
  private String baseUnit;
  
/*  *//**
   * 计量单位   
   *//*
  @ExcelImportAnnotation(column = "6", isDate = false, columnName = "计量单位")
  private String unit;
  
  *//**
   * 系数
   *//*
  @ExcelImportAnnotation(column = "7", isDate = false, columnName = "系数")
  private String coefficient;*/
  
  /**
   * 安全库存
   */
  @ExcelImportAnnotation(column = "6", isDate = false, columnName = "安全库存")
  private String safeStock;
  
  /**
   * 最小采购量
   */
  @ExcelImportAnnotation(column = "7", isDate = false, columnName = "最小采购量")
  private String minPurchaseAmount;
  
  /**
   * 条码管理 
   */
 
  @ExcelImportAnnotation(column = "8", isDate = false, columnName = "条码管理")
  private String barCodeManage;
  
  /**
   * 批次管理 
   */
 
  @ExcelImportAnnotation(column = "9", isDate = false, columnName = "批次管理")
  private String lotManage;

  /**
   * 保质期管理    
   */
  @ExcelImportAnnotation(column = "10", isDate = false, columnName = "保质期管理")
  private String expiraDateManage;
  
  /**
   * 保质期  
   */
  @ExcelImportAnnotation(column = "11", isDate = false, columnName = "保质期")
  private String expiraData;
  /**
   * 保质期单位    
   */
  @ExcelImportAnnotation(column = "12", isDate = false, columnName = "保质期单位")
  private String expiraDataUtil;
  
  /**
   * 图片
   */
  @ExcelImportAnnotation(column = "13", isDate = false, columnName = "商品图片")
  private String picture;
  /**
   * 创建人
   */
  @ExcelImportAnnotation(column = "14", isDate = false, columnName = "创建人")
  private String createUserName;
  
  /**
   * 创建时间
   */
  @ExcelImportAnnotation(column = "15", isDate = true, columnName = "创建时间")
  private String createTime;
  /**
   * 更新人
   */
  @ExcelImportAnnotation(column = "16", isDate = false, columnName = "最后修改人")
  private String updateUserName;
  /**
   * 更新时间
   */
  @ExcelImportAnnotation(column = "17", isDate = true, columnName = "最后修改时间")
  private String updateTime;
  
  
  public String getNumber() {
    return number;
  }
  public void setNumber(String number) {
    this.number = number;
  }
  public String getBarCode() {
    return barCode;
  }
  public void setBarCode(String barCode) {
    this.barCode = barCode;
  }
  public String getMatCategoryCode() {
    return matCategoryCode;
  }
  public void setMatCategoryCode(String matCategoryCode) {
    this.matCategoryCode = matCategoryCode;
  }
  public String getName() {
    return name;
  }
  public void setName(String name) {
    this.name = name;
  }
  public String getStandard() {
    return standard;
  }
  public void setStandard(String standard) {
    this.standard = standard;
  }
  public String getBaseUnit() {
    return baseUnit;
  }
  public void setBaseUnit(String baseUnit) {
    this.baseUnit = baseUnit;
  }
/*  public String getUnit() {
    return unit;
  }
  public void setUnit(String unit) {
    this.unit = unit;
  }
  public String getCoefficient() {
    return coefficient;
  }
  public void setCoefficient(String coefficient) {
    this.coefficient = coefficient;
  }*/
  public String getSafeStock() {
    return safeStock;
  }
  public void setSafeStock(String safeStock) {
    this.safeStock = safeStock;
  }
  public String getMinPurchaseAmount() {
    return minPurchaseAmount;
  }
  public void setMinPurchaseAmount(String minPurchaseAmount) {
    this.minPurchaseAmount = minPurchaseAmount;
  }
  public String getBarCodeManage() {
    return barCodeManage;
  }
  public void setBarCodeManage(String barCodeManage) {
    this.barCodeManage = barCodeManage;
  }
  public String getLotManage() {
    return lotManage;
  }
  public void setLotManage(String lotManage) {
    this.lotManage = lotManage;
  }
  public String getExpiraDateManage() {
    return expiraDateManage;
  }
  public void setExpiraDateManage(String expiraDateManage) {
    this.expiraDateManage = expiraDateManage;
  }
  public String getExpiraData() {
    return expiraData;
  }
  public void setExpiraData(String expiraData) {
    this.expiraData = expiraData;
  }
  public String getExpiraDataUtil() {
    return expiraDataUtil;
  }
  public void setExpiraDataUtil(String expiraDataUtil) {
    this.expiraDataUtil = expiraDataUtil;
  }
  public String getPicture() {
    return picture;
  }
  public void setPicture(String picture) {
    this.picture = picture;
  }
  public String getCreateUserName() {
    return createUserName;
  }
  public void setCreateUserName(String createUserName) {
    this.createUserName = createUserName;
  }
  public String getCreateTime() {
    return createTime;
  }
  public void setCreateTime(String createTime) {
    this.createTime = createTime;
  }
  public String getUpdateUserName() {
    return updateUserName;
  }
  public void setUpdateUserName(String updateUserName) {
    this.updateUserName = updateUserName;
  }
  public String getUpdateTime() {
    return updateTime;
  }
  public void setUpdateTime(String updateTime) {
    this.updateTime = updateTime;
  }
  
  
}
